How to: Save only part of a worksheet.
Solution:
Copy the part of a worksheet to be saved, paste it into a new workbook, and save the new workbook.
1) Copy the part of the worksheet to be saved:
a) Select the desired range of cells.
b) Select the 'Edit' menu and select 'Copy'.
2) Create a new, blank workbook:
a) Select the 'File' menu and select 'New...'. (The New dialog box appears.)
b) Click the 'General' tab. (The 'General' tab page appears.)
c) Open the ' Workbook' icon.
'General' tab - 'Workbook' icon
d) Click 'OK'. (A blank workbook appears.)
3) Select a cell in the new workbook.
NOTE: This cell is the upper left-hand corner of the new location for the copied cells.
4) Select the 'Edit' menu and select 'Paste' to paste the copied cells into the new workbook.
5) Save the new workbook:
a) Select the 'File' menu and select 'Save'. (The' Save As' dialog box appears.)
b) Select the drive where the workbook is to be saved from the 'Save in' drop-down list box. (A list of folders within the drive appears.)
Selecting the drive
c) (Optional) Open the desired folder:
1] Click on the folder.
2] Click 'Open'.
d) Type a filename for the workbook in the 'File name' drop-down list box.
the File name drop-down list box
NOTE: A filename can contain up to 255 characters, including spaces.
e) Select 'Microsoft Excel Workbook (*.XLS)' from the 'Save as type' drop-down list box.
f) Click 'Save'.
